MariaDB must map PKI ID to an associated user account.

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-253701	MADB-10-004200	SV-253701r841628_rule		Medium

Description
The DoD standard for authentication is DoD-approved PKI certificates. Once a PKI is validated, it is mapped to the DBMS user account for the authentication identity and then can be used for authorization decisions.

STIG	Date
MariaDB Enterprise 10.x Security Technical Implementation Guide	2022-08-24

Details

Check Text ( C-57153r841626_chk )
Query all users to confirm issuer and subject are configured correctly: MariaDB>SELECT user, host, ssl_type, CAST(x509_issuer AS CHAR) AS issuer, CAST(x509_subject AS CHAR) AS subject FROM mysql.user; If users are not mapped correctly, this is a finding.

Fix Text (F-57104r841627_fix)
Example command to create users with proper X509 certificate subject and issuer: MariaDB>CREATE USER 'janedoe'@'%' IDENTIFIED BY 'Some_Password_Here_$9' REQUIRE SUBJECT '/C=US/ST=Ohio/L=Columbus/O=MariaDB Corporation/CN=Jane Doe' AND ISSUER '/C=US/ST=Ohio/L=Columbus/O=MariaDB Corporation/CN=MariaDB CA';